-- Create table
create table TAB_PAREA_INDICATOR_LIB_CFG
(
  id              bigint    comment  'ID'
  ,indicator_item  string    comment o '指标项显示的字段名'
  ,indicator_desc  string    comment  '指标项描述'
  ,indicator_field string    comment  '指标项返回字段'
  ,agent_code      string    comment  '代理区code'
  ,agent_name      string    comment  '代理区名称'
  ,weight          bigint    comment  '权重'
  ,update_time     date      comment  '更新时间'
  ,create_time     date      comment  '创建时间'
  ,create_by       string    comment  '创建人'
  ,modify_by       string    comment  '更新人'
)comment '指标项库'
PARTITIONED BY (
  `dt` string COMMENT '分区(yyyy-mm-dd)')
STORED AS PARQUET
LOCATION
  '/dw/hive/jms_ods.db/external/tab_parea_indicator_lib_cfg';